MICROSOFT CERTIFIED DATABASE ADMINISTRATOR 2003/ SQL SERVER 2000 MCDBA CURRICULUM

  1. Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment
  2. Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
  3. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
  4. Microsoft SQL Server 2000 Enterprise Edition

I. Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment

  • Basic Concepts
  • 1.25 Hours

  • Managing Users, Groups and Computers
  • 2.75 Hours

  • Managing Resource Access
  • 3 Hours

  • Managing Hardware, Disks and Logical Devices
  • 2.75 Hours

  • Managing the Server Environment
  • 3.75 Hours

  • Managing Disaster Recovery
  • 2.25 Hours


    II. Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

  • Planning the Network Infrastructure
  • 3.75 Hours

  • Planning for Name Resolution
  • 3 Hours

  • Implementing Routing and Remote Access
  • 3 Hours

  • Planning for Network Availability
  • 2 Hours

  • Planning Server Roles and Server Security
  • 2.75 Hours

  • Planning a Security Infrastructure
  • 3 Hours


    III. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
  • 1.75 Hours

  • Installing, Configuring and Upgrading SQL Server 2000
  • 2 Hours

  • SQL Server 2000 Databases
  • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
  • 1.50 Hours

  • Security in a Microsoft SQL Server 2000 Environment
  • 2 Hours

  • Managing SQL Server 2000 Databases
  • 2.75 Hours

  • Backing Up SQL Server 2000 Databases
  • 2.25 Hours

  • Restoring SQL Server 2000 Databases
  • 1.75 Hours

  • SQL Server 2000 Replication
  • 1.75 Hours

  • Monitoring SQL Server 2000 Performance
  • 1.50 Hours

  • SQL Server 2000 High Availability
  • 1 Hour

  • SQL Server 2000, XML and the Web
  • 1.50 Hours


    IV. Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
  • 1.75 Hours

  • SQL Server 2000 Databases
  • 1.75 Hours

  • Designing and Implementing Security in SQL Server 2000
  • 1.25 Hours

  • The SQL Server 2000 Logical Data Model
  • 2.50 Hours

  • Using T-SQL in SQL Server 2000
  • 3 Hours

  • SQL Server 2000 Indexes
  • 2 Hours

  • SQL Server 2000 Programming and Business Logic
  • 2.75 Hours

  • SQL Server 2000 Transactions and Distributed Data
  • 1.75 Hours

  • Analyzing and Optimizing SQL Server 2000 Queries
  • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
  • 1.50 Hours

  • SQL Server 2000, XML and the Web
  • 1.50 Hours